</> SQL

booking_system

CREATE TABLE bookings (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(120),
email VARCHAR(150),
whatsapp VARCHAR(30),
destination VARCHAR(150),
travel_date DATE,
travelers INT,
status VARCHAR(50) DEFAULT 'Pending',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE quotes (
id INT AUTO_INCREMENT PRIMARY KEY,
client_name VARCHAR(120),
email VARCHAR(150),
destination VARCHAR(150),
estimated_price DECIMAL(10,2),
status VARCHAR(50) DEFAULT 'Draft',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE tour_packages (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(150),
country VARCHAR(100),
duration VARCHAR(50),
description TEXT,
price DECIMAL(10,2),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE invoices (
id INT AUTO_INCREMENT PRIMARY KEY,
client_name VARCHAR(120),
email VARCHAR(150),
amount DECIMAL(10,2),
status VARCHAR(50) DEFAULT 'Unpaid',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE itineraries (
id INT AUTO_INCREMENT PRIMARY KEY,
client_name VARCHAR(120),
tour_title VARCHAR(150),
details TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
